<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="Managing ClickHouse Database/Table Set Protection">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="clickhouse-0054.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="30-OceanProtect Appliance 1.5.0-1.6.0 Help Center">
<meta name="DC.Publisher" content="20241029">
<meta name="prodname" content="csbs">
<meta name="documenttype" content="usermanual">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="clickhouse-0057">
<meta name="DC.Language" content="en-us">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>Managing ClickHouse Database/Table Set Protection</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="clickhouse-0057"></a><a name="clickhouse-0057"></a>

<h1 class="topictitle1">Managing ClickHouse Database/Table Set Protection</h1>
<div><p>This section describes how to modify, remove, activate, or disable ClickHouse database/table set protection on the <span>OceanProtect</span>.</p>
<div class="section"><h4 class="sectiontitle">Related Operations</h4><p>Choose <span class="uicontrol"><b><span id="clickhouse-0057__en-us_topic_0000001839142377_text1926371213406"><strong>Protection</strong></span> &gt; Big Data &gt; ClickHouse</b></span>, click the <span class="uicontrol"><b><span><strong>Databases</strong></span></b></span> or <span class="uicontrol"><b><span><strong>Table Sets</strong></span></b></span> tab, and locate the database or table set on which you want to perform related operations.</p>
</div>
<p><a href="#clickhouse-0057__table24934294919">Table 1</a> describes related operations.</p>

<div class="tablenoborder"><a name="clickhouse-0057__table24934294919"></a><a name="table24934294919"></a><table cellpadding="4" cellspacing="0" summary="" id="clickhouse-0057__table24934294919" frame="border" border="1" rules="all"><caption><b>Table 1 </b>Database/Table set protection operations</caption><colgroup><col style="width:14.35%"><col style="width:57.92%"><col style="width:27.73%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="14.35%" id="mcps1.3.4.2.4.1.1"><p>Operation</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="57.92%" id="mcps1.3.4.2.4.1.2"><p>Description</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="27.73%" id="mcps1.3.4.2.4.1.3"><p>Navigation Path</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="14.35%" headers="mcps1.3.4.2.4.1.1 "><p><span><strong>Modify Protection</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="57.92%" headers="mcps1.3.4.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>If you need to reselect an SLA associated with a database or table set, you can modify the protection plan. After the modification, the next backup will be executed based on the new protection plan.</p>
<p><strong>Note</strong></p>
<p>The modification does not affect the protection job that is being executed. The modified protection plan will take effect in the next protection period.</p>
</td>
<td class="cellrowborder" valign="top" width="27.73%" headers="mcps1.3.4.2.4.1.3 "><p>In the row where the database or table set resides, choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Modify Protection</strong></span></b></span>.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.35%" headers="mcps1.3.4.2.4.1.1 "><p><span><strong>Remove Protection</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="57.92%" headers="mcps1.3.4.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to remove the protection of a database or table set when it does not need to be protected. After the removal, the system cannot execute protection jobs for the database or table set. To protect the database or table set again, associate an SLA with it again.</p>
<p><strong>Note</strong></p>
<p>Protection cannot be removed when a protection job of the database or table set is running.</p>
</td>
<td class="cellrowborder" valign="top" width="27.73%" headers="mcps1.3.4.2.4.1.3 "><p>In the row where the database or table set resides, choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Remove Protection</strong></span></b></span>.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.35%" headers="mcps1.3.4.2.4.1.1 "><p><span><strong>Activate Protection</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="57.92%" headers="mcps1.3.4.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to re-activate a disabled protection plan of a database or table set. After the protection plan is activated, the system backs up the database or table set based on the protection plan.</p>
<p><strong>Note</strong></p>
<p>You can perform this operation only when the database or table set has been associated with an SLA and is in <span class="uicontrol"><b><span><strong>Inactivated</strong></span></b></span> status.</p>
</td>
<td class="cellrowborder" valign="top" width="27.73%" headers="mcps1.3.4.2.4.1.3 "><p>In the row where the database or table set resides, choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Activate Protection</strong></span></b></span>.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.35%" headers="mcps1.3.4.2.4.1.1 "><p><span><strong>Disable Protection</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="57.92%" headers="mcps1.3.4.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to disable the protection plan of a database or table set when its periodic protection is not needed. After the protection plan is disabled, the system does not execute the automatic backup job of the database or table set.</p>
<p><strong>Note</strong></p>
<p>Disabling protection does not affect ongoing backup jobs.</p>
</td>
<td class="cellrowborder" valign="top" width="27.73%" headers="mcps1.3.4.2.4.1.3 "><p>In the row where the database or table set resides, choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Disable Protection</strong></span></b></span>.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.35%" headers="mcps1.3.4.2.4.1.1 "><p><span><strong>Manual Backup</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="57.92%" headers="mcps1.3.4.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to perform a backup immediately.</p>
<p><strong>Note</strong></p>
<p>Copies generated by manual backup are retained for the duration defined in the SLA.</p>
</td>
<td class="cellrowborder" valign="top" width="27.73%" headers="mcps1.3.4.2.4.1.3 "><p>In the row where the database or table set resides, choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Manual Backup</strong></span></b></span>.</p>
</td>
</tr>
<tr><td class="cellrowborder" colspan="3" valign="top" headers="mcps1.3.4.2.4.1.1 mcps1.3.4.2.4.1.2 mcps1.3.4.2.4.1.3 "><p>Note: The procedure for restoring ClickHouse databases or table sets is similar to that in <a href="clickhouse-0043.html">Restoring a ClickHouse Database or Table Set</a> and is not described here.</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="clickhouse-0054.html">ClickHouse Cluster Environment</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">Copyright &copy; Huawei Technologies Co., Ltd.</div></body>
</html>